package com.ssm.gbq.mapper;

import com.ssm.gbq.model.Doctor;
import gbq.ssm.utils.PageBounds;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface DoctorMapper {
    int countByExample(@Param("doctorName") String doctorName,@Param("createTimeMax")String createTimeMax,@Param("createTimeMin")String createTimeMin);
    int Count();
    List<Doctor> selectByLimitPage(@Param("doctorName")String doctorName,@Param("createTimeMax")String createTimeMax,@Param("createTimeMin")String createTimeMin, @Param("offset") int offset, @Param("limit")int pageSize);
    /**
     * 获取列表
     */
    PageBounds<Doctor> openDoctorTable(@Param("doctorName")String doctorName, int currentPage, int pageSize)throws Exception;
    /**
     * 查询所有信息
     */
    List<Doctor> selectAllDoctor();
    /**
     *删除信息
     */
    int deleteDoctorById(Integer id);
    /**
     * 多删除
     */
    int deleteByPrimaryKey(List<Integer> ids);
    /**
     * 添加
     */
    public int  addDoctor(Doctor doctor);
    /**
     * 修改
     */
    public int  updateDoctor(Doctor doctor);
    /**
     *根据ID查询
     */
    public Doctor findById(@Param("id")Integer id);
    /**
     *根据类别查询
     */
    public int findByType(List<Integer> typeid);

}
